WIP Activity Net of Retainers

The WIP Activity Net of Retainers report shows WIP activity totals for a specified period, allowing you to review WIP activity for a selected date range. The report also includes progress bills generated and applied to the WIP and the beginning and ending WIP balance.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

  • Security group profile > Functional rights > Reports > Shared Library > Shared Views
  • Security group profile > Functional rights > Reports > Firm Library > Custom
  • Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
  • Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
  • Security group profile > Functional rights > Reports > Firm Library > <report name>
  • Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients

Reports in Foundation that are Comparable

In Practice Management, the comparable report is WIP Activity Net of Retainers. In Practice Advantage, there is no comparable report.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings    
Option Setting Description

Select to Include Transactions Using…

List

Determines the type of transaction date to use. The options are Transaction Date and Accounting Period Date.

Hide Comma

Yes/No

Includes or excludes commas in numbers.

Hide Penny

Yes/No

Includes or excludes pennies in amounts.

Include Deleted Clients

Yes/No

Includes or excludes deleted client information.

Default Filters
Field Name Operator Value

PTD

Between

First Day of Current Month, Today

RTD

Between

First Day of Current Fiscal Year, Last Day of Current Fiscal Year

Notes:

  • The PTD (period to date) fields may display values for a more limited period, such as a month or a quarter. The RTD (range to date) fields display values for a longer time span, such as a fiscal or calendar year. The date values entered for PTD must be within the RTD date values.
  • If you remove the PTD and RTD fields and later decide they should be selected, use Reset Defaults to add these fields. If you manually add these fields, the logic statement used between the fields is AND instead of OR, causing inaccurate reporting data.
Optional Filters    
Available Fields

Business Code

Client Type

PTD WIP Balance

Client

Financial Reporting Client Group

PTD WIP Beg Balance

Client – Principal

Line of Business

PTD WIP Write Up/Down

Client Bill Manager

Manager

Return Group

Client Business Unit

Primary Partner

RTD

Client ID

PTD

RTD % Relieved WIP Adjust

Client ID.Sub ID

PTD % Relieved WIP Adjust

RTD Billed Amounts

Client Name

PTD Billed Amounts

RTD Production Amounts

Client Office

PTD Production Amounts

RTD Progress Applied

Client Primary Service Type

PTD Progress Applied

RTD Progress Billed

Client Region

PTD Progress Billed

RTD WIP %

Client Sub ID

PTD WIP %

RTD WIP Balance

RTD WIP Beg Balance

RTD Write Up/Down

Tax Type

RTD WIP End Balance

Sort Name

 

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping    
Available Fields

Business Code

Client Name

Line of Business

Client

Client Office

Manager

Client – Principal

Client Primary Service Type

Primary Partner

Client Bill Manager

Client Region

Return Group

Client Business Unit

Client Sub ID

Sort Name

Client ID

Client Type

Tax Type

Client ID.Sub ID

Financial Reporting Client Group

 

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting

Client

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields  
Field Description

Client

The client name in Client Name (Client ID.Sub-ID) format.

WIP Beg Balance

The total of all open WIP as of the date range selected.

Production Amounts

The total of all billable WIP posted for the date range selected, including expenses and surcharges.

WIP Balance

The total WIP balance for the date range selected. The calculation is WIP beginning balance + production amounts.

Billed Amounts

The total of billed WIP amounts on posted invoices for the date ranged selected, including expenses and surcharges.

Write Up/Down

The total of all write up/down amounts for the date range selected.

Progress Billed

The total progress billed for the date range selected.

Progress Applied

The total progress applied for the date range selected.

WIP End Balance

The ending WIP balance for the date range selected. The calculation is WIP beginning balance + production amounts – billed amounts – progress billed + progress applied.

WIP %

The WIP percentage for the date range selected. The calculation is (billed amounts – write up/down – progress billed + progress applied)/WIP balance.

% Relieved WIP Adjust

The percentage of the relieved WIP adjustment for the date range selected. The calculation is write up/down/(billed amounts – write up/down – progress billed + progress applied).

WIP Activity Net of Retainers Sample Report